SPR

Technote

Problem:
This issue was reported to Lotus Software Quality Engineering and has been
addressed in Notes/Domino 4.6.7 and 5.0.3.

Excerpt from the Fix Lists for Lotus Notes and Lotus Domino Release 4.6.7 and
5.0.3 QMR's:

LS:DO

SPR# PJAN4DCHWV - Fix a crash which occurred when doing an SQL INSERT of a long
string. [4.6.7]

You can work around the issue, using the SetValue and UpdateRow approach. The
following script will update the back-end field with the 1500-character string
and does not cause a crash.

'Same code leading up to the sqlStatement line.
sqlStatement = "SELECT * FROM LONGSTRING WHERE ID = '1' "
Qry.SQL = sqlStatement
Set res.Query = Qry
status = res.Execute
status = res.setvalue("LSTRING",newDesc)
status = res.updaterow
res.close(DB_CLOSE)
con.DisConnect

Supporting Information:

The following code causes Notes to crash on the qry.sql= line:

Dim Con As New ODBCConnection
Dim Qry As New ODBCQuery
Dim res As New ODBCResultSet
newDesc = "A string of 1500 characters"
Con.ConnectTo("DSN")
Set Qry.Connection = Con
sqlStatement = "UPDATE LONGSTRING SET LSTRING = '" + newDesc+"' WHERE ID =
'1'"
Qry.SQL = sqlStatement 'This line causes the crash.
Set res.Query = Qry
status = res.Execute
res.close(DB_CLOSE)
con.DisConnect

Note that the above script does not cause a crash when the newDesc string
variable is set to a 500-character string.
More >